Tabela SysMap

Definicja tabeli SysMap

Name

SysMap

Code

SysMap

Comment

 


Lista kolumn tabeli SysMap

Name

Code

SysMapTypeID

SysMapTypeID

SysTabID

SysTabID

SystemID

SystemID

ID

ID

InternalIdentifier

InternalIdentifier

ExternalIdentifier

ExternalIdentifier

ImportFlague

ImportFlague

PerNoOfUnits

PerNoOfUnits

UnitsCount

UnitsCount

IsPrimary

IsPrimary

ExternalHashCode

ExternalHashCode

SysMapContextID

SysMapContextID


Kolumna SysMapTypeID tabeli SysMap

Definicja kolumny SysMapTypeID tabeli SysMap

Name

SysMapTypeID

Code

SysMapTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SysTabID tabeli SysMap

Definicja kolumny SysTabID tabeli SysMap

Name

SysTabID

Code

SysTabID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SystemID tabeli SysMap

Definicja kolumny SystemID tabeli SysMap

Name

SystemID

Code

SystemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ID tabeli SysMap

Definicja kolumny ID tabeli SysMap

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InternalIdentifier tabeli SysMap

Definicja kolumny InternalIdentifier tabeli SysMap

Name

InternalIdentifier

Code

InternalIdentifier

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalIdentifier tabeli SysMap

Definicja kolumny ExternalIdentifier tabeli SysMap

Name

ExternalIdentifier

Code

ExternalIdentifier

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ImportFlague tabeli SysMap

Definicja kolumny ImportFlague tabeli SysMap

Name

ImportFlague

Code

ImportFlague

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PerNoOfUnits tabeli SysMap

Definicja kolumny PerNoOfUnits tabeli SysMap

Name

PerNoOfUnits

Code

PerNoOfUnits

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli SysMap

Definicja kolumny UnitsCount tabeli SysMap

Name

UnitsCount

Code

UnitsCount

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna IsPrimary tabeli SysMap

Definicja kolumny IsPrimary tabeli SysMap

Name

IsPrimary

Code

IsPrimary

Data Type

NUMBER(5)

Mandatory

No

Comment

Kolumna IsPrimary pozwoli wskazuje, który z identyfikatorów jest identyfikatorem glównym w przypadku gdy dany byt w bazie CN posiada wiecej niz jeden identyfikator danego typu w okreslonym systemie


Kolumna ExternalHashCode tabeli SysMap

Definicja kolumny ExternalHashCode tabeli SysMap

Name

ExternalHashCode

Code

ExternalHashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Suma kontrolna (np. MD5 hashcode) rekordu w systemie zewnetrznym


Kolumna SysMapContextID tabeli SysMap

Definicja kolumny SysMapContextID tabeli SysMap

Name

SysMapContextID

Code

SysMapContextID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli SysMap

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SysMap

Definicja klucza Identifier_1 tabeli SysMap

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment